Hamburg, DEBest practices for using KEEPFILTERS in DAX
Marco Russo & Alberto FerrariThis article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
The Optimizing DAX book is available
We are proud to announce the availability of our new book, Optimizing DAX. Read more
May 27 - Amsterdam
Aug 9 - Melbourne
Sep 23-25 - Vancouver
Jun 25-27 - Chicago
Video Training
Introducing DAX Video CourseFree
Comparing cumulative values for events in different periods
Kurt BuhlerThis article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
Author’s responsibility
Marco RussoDigital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself. Read more
DAX Patterns
Like-for-like comparison
The like-for-like sales comparison is an adjusted metric that compares two time periods restricting the comparison to products or stores with the same characteristics In this example we use the like-for-like technique to compare the sales of Contoso stores that… More on DAX Patterns
SQLBI Corp.
Optimizing DAX, Second Edition
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more